// MountainMgr.java
import java.util.*;
import Database;
import DbRowSet;
import Mountain;

public class MountainMgr {
  private static String select =
        "select mountain_id," +
             "mountain_name," +
             "location," +
             "king_id," +
             "dwarf_name as king_name " +
           "from mountain " +
           "left join dwarf on king_id = dwarf_id ";

  public static List GetAll() throws java.sql.SQLException {
    DbRowSet res = Database.RunSql(select);
    List ret = new LinkedList();

    while(res.next()){
      Mountain m = new Mountain(res.getInt("mountain_id"),
                                res.getString("mountain_name"),
                                res.getString("location"),
                                res.getInt("king_id"),
                                res.getString("king_name"));
      ret.add(m);
    } 

    return ret;
  } 

  public static Mountain Get(int mountain_id) throws java.sql.SQLException {
    String lselect = select + " where mountain_id = ?"; 
    List params = new LinkedList();
    params.add(new Integer(mountain_id));
    DbRowSet res = Database.RunSql(lselect,params);
    Mountain m = null;

    while(res.next()){
      m = new Mountain(res.getInt("mountain_id"),
                                res.getString("mountain_name"),
                                res.getString("location"),
                                res.getInt("king_id"),
                                res.getString("king_name"));
    }

    return m;
  } 

  public static int Add(String mountain_name,
                        String location,
                        int king_id) throws java.sql.SQLException
  {
    List params = new LinkedList();
    params.add(mountain_name);
    params.add(location);

    if(king_id != 0)
      params.add(new Integer(king_id));
    else     
      params.add(null);

    Database.RunSql(
      "insert into mountain (mountain_name,location,king_id) values (?,?,?)",
      params);

    // return mountian_id later...
    return 0;
  } 

  public static void Update(int mountain_id, String mountain_name,
                            String location, int king_id)
    throws java.sql.SQLException
  {
    List params = new LinkedList();
    params.add(mountain_name);
    params.add(location);

    if(king_id != 0)
      params.add(new Integer(king_id));   
    else     
      params.add(null); 

    params.add(new Integer(mountain_id));

    Database.RunSql(
      "update mountain set mountain_name = ?,"+
            "location = ?," +
            "king_id = ? " +
          "where mountain_id = ?",
      params);
  }
}